<!doctype HTML public "-//W3C//DTD HTML 4.0 Frameset//EN">
<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
<meta name="generator" content="Adobe RoboHelp - www.adobe.com">
<title>Shortcut-to-a-filter qualification</title>
<link rel="stylesheet" href="userhelp_ns.css"><script type="text/javascript" language="JavaScript" title="WebHelpSplitCss">
<!--
if (navigator.appName !="Netscape")
{   document.write("<link rel='stylesheet' href='userhelp.css'>");}
//-->
</script>
<style type="text/css">
<!--
ol.whs1 { list-style:decimal; }
p.whs2 { font-size:9pt; }
ul.whs3 { list-style:disc; }
-->
</style><script type="text/javascript" language="JavaScript" title="WebHelpInlineScript">
<!--
function reDo() {
  if (innerWidth != origWidth || innerHeight != origHeight)
     location.reload();
}
if ((parseInt(navigator.appVersion) == 4) && (navigator.appName == "Netscape")) {
	origWidth = innerWidth;
	origHeight = innerHeight;
	onresize = reDo;
}
onerror = null; 
//-->
</script>
<style type="text/css">
<!--
div.WebHelpPopupMenu { position:absolute; left:0px; top:0px; z-index:4; visibility:hidden; }
-->
</style><script type="text/javascript" language="javascript1.2" src="whmsg.js"></script>
<script type="text/javascript" language="javascript" src="whver.js"></script>
<script type="text/javascript" language="javascript1.2" src="whproxy.js"></script>
<script type="text/javascript" language="javascript1.2" src="whutils.js"></script>
<script type="text/javascript" language="javascript1.2" src="whlang.js"></script>
<script type="text/javascript" language="javascript1.2" src="whtopic.js"></script>
</head>
<body><script type="text/javascript" language="javascript1.2">
<!--
if (window.gbWhTopic)
{
	if (window.addTocInfo)
	{
	addTocInfo("Creating and modifying reports\nRetrieving specific data from sources: Filters\nCreating a stand-alone filter\nShortcut-to-a-filter qualification");
addButton("show",BTN_TEXT,"Show","","","","",0,0,"","","");

	}
	if (window.writeBtnStyle)
		writeBtnStyle();

	if (window.writeIntopicBar)
		writeIntopicBar(1);

	if(1)
	{
	
	}

	if (window.setRelStartPage)
	{
	setRelStartPage("MicroStrategy_Web_Help.htm");

		autoSync(1);
		sendSyncInfo();
		sendAveInfoOut();
	}
}
else
	if (window.gbIE4)
		document.location.reload();

//-->
</script>
<h1>Shortcut-to-a-filter qualification</h1>
<p>A shortcut-to-a-filter qualification allows you to move an existing 
 filter into a new filter, and apply the new filter to a report. You can 
 also add additional conditions to the new filter and then apply the new 
 filter to the report. For example, Filter 1 contains two conditions, A 
 and B. You can use Filter 1 as the basis of a new filter, and then add 
 another condition C to the new filter. The data that is filtered for must 
 then satisfy all three conditions A, B, and C to be included in any report 
 which uses the new filter. Note that Filter 1remains unchanged throughout 
 this process.</p>
<p>For example, you are a manager in New England, responsible for stores 
 in Boston, Providence, and Greenwich. Your project contains a filter called 
 Stores In My Region, which is defined as the Boston, Providence, and Greenwich 
 stores. A second filter, called Women's Clothing filter, includes the 
 categories Blouses and Dresses. A third filter, All Days in December 2008, 
 is a date range that includes all the days in the month of December 2008. 
 To study December sales in your stores for women's clothing, you create 
 a new filter. The new filter includes a shortcut to each of the three 
 filters. Use this new filter in your report. The original three filters 
 are unchanged, which is useful for other reports that use one or more 
 of those filters.</p>
<p>You can also use an existing filter as a base for a new filter and then 
 add additional qualifications to expand the overall filter definition. 
 For example, you can take a filter that screens data for all customers 
 in the Southwest region, place that filter into a new filter, and add 
 a new filter qualification for active customers in the current year. The 
 new filter screens data for all currently active customers in the Southwest 
 region.</p>
<p>This approach shows you the value of creating some basic, relatively 
 simple filters in your project, such as a filter for customers in a specific 
 region. Then you can make use of these basic filters within shortcut-to-a-filter 
 filters to make the filter creation process quicker.</p>
<h2>To create a filter based on another filter</h2>
<ol type="1" class="whs1">
	
<li class=p><p>On the project's main page, click <span style="font-weight: bold;"><B>Create 
 Filter</B></span>. The New Filter page opens.</p></li>
	
<li class=p><p>In the pane on the left, navigate to the filter you 
 want to use in the new filter.</p></li>
	
<li class=p><p>Right-click the filter and select <span style="font-weight: bold;"><B>Add 
 to Filter</B></span>.</p></li>
	<ul>
<li style="list-style: disc;" type=disc class=p><p>If DHTML is 
 disabled, select the report and click <span style="font-weight: bold;"><B>Add 
 &gt;</B></span> to add the report to the Filter panel.</p></li>
	</ul>
	
<li class=p><p>From the <span style="font-weight: bold;"><B>File</B></span> 
 menu, select <span style="font-weight: bold;"><B>Save As</B></span>. The Save 
 As dialog box opens.</p></li>
	
<li style=" font-size: 9pt; " class=p><p><span style="font-size: 9pt;"><font size=1 style="font-size:9pt;">Navigate 
 to the folder where you want to save the filter. Enter a </font></span><span 
 style="font-size: 9pt; font-weight: bold;"><font size=1 style="font-size:9pt;"><B>Name</B></font></span><span style="font-size: 9pt;"><font size=1 style="font-size:9pt;"> 
 and </font></span><span style="font-size: 9pt; font-weight: bold;"><font size=1 style="font-size:9pt;"><B>Description</B></font></span><span 
 style="font-size: 9pt;"><font size=1 style="font-size:9pt;"> for the filter, and click </font></span><span style="font-size: 9pt; font-weight: bold;"><font size=1 style="font-size:9pt;"><B>OK</B></font></span><span 
 style="font-size: 9pt;"><font size=1 style="font-size:9pt;">. Your new filter is saved.</font></span></p></li>
</ol>
<p class="whs2">The filter you created can now be added to a 
 report. For steps, see 
<a href="Creating_a_filter.htm" style="font-size: 9pt;">Adding 
 a stand-alone filter to a report</a>.</p>
<p class="whs2">&nbsp;</p>
<h2>Joining filter qualifications with operators</h2>
<p class="whs2">When a filter has multiple qualifications, they 
 are always joined by operators. When qualifications are joined, operators 
 govern the interaction between different filtering conditions. Whenever 
 you have more than one qualification in a report filter, you can define 
 the operator as any of the following:</p>
<ul type="disc" class="whs3">
	
<li class=p><p class="whs2">AND</p></li>
	
<li class=p><p class="whs2">OR</p></li>
	
<li class=p><p class="whs2">OR NOT</p></li>
	
<li class=p><p class="whs2">AND NOT</p></li>
</ul>
<p class="whs2">The AND operator is the operator assigned by 
 default when more than one qualification is added to a filter. You can 
 change the default AND operator by simply right-clicking on the word AND 
 in the filter&rsquo;s definition pane, pointing to <span style="font-weight: bold;"><B>Toggle 
 Operator</B></span>, and selecting a different operator. </p>
<p class="whs2">Each of the operators listed above is described 
 below, with a report example.</p>
<p class="whs2">For more information on advanced operators to 
 apply to a report limit, see <span style="font-style: italic;"><I>Appendix 
 B: Logical and Mathematical Operators for Filtering in the MicroStrategy 
 Advanced Reporting Guide</I></span>.</p>
<h3>The AND operator</h3>
<p class="whs2">By default, the operator AND is inserted between 
 filter qualifications. </p>
<h3><span style="font-size: 9pt;"><font size=1 style="font-size:9pt;">The OR operator</font></span></h3>
<p class="whs2">For those familiar with logic terminology, the 
 OR operator acts as an inclusive OR, not an exclusive OR.</p>
<h3>The OR NOT operator</h3>
<h3>The AND NOT operator</h3>
<p class="whs2">&nbsp;</p>
<p class="whs2">&nbsp;</p>
<script type="text/javascript" language="javascript1.2">
<!--
highlightSearch();
if (window.writeIntopicBar)
	writeIntopicBar(0);
if(0)
{

}
//-->
</script>
</body>
</html>
